<!--center begin-->
		<div id="sidebar_center">
			<div id="news">
				<dl>
					<dt>
						<a class="news_nav article_golink" href="">通知公告</a>
					</dt>
				</dl>
				
				<ul>
                            <?php 
                                     $sql_announcement = "select id,title,datetime from nettteach_announcement where display='0' order by datetime DESC limit 0,8 ";
                                     $result_announcement = $db -> query($sql_announcement);
                                     while($row_announcement = $db ->fetch_array($result_announcement))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_announcement['title']?>">
                                    <span class="date">[<?php echo date("Y-m-d",$row_announcement['datetime'])?>]</span>
                                    <a style="color:blue" href="?do=announce&announceid=<?php echo $row_announcement['id']?>" title=""><?php echo $row_announcement['title']?></a>
                            </li>
                            <?php }?>
					<span class="more"><a href="?do=announcelist" target="_self">更多>></a></span>
				</ul>
			</div>	

			<dl class="box1" style="padding-bottom: 10px">
				<dt>
					<ul id="nav-table">
						<li class="active" onclick='return secBoard(0)'><a class="article_golink" href="#">最新下载</a></li>
						<li onclick='return secBoard(1)'><a class="article_golink" href="#">最新视频</a></li>
						<li onclick='return secBoard(2)'><a class="article_golink" href="#">最新试题</a></li>
					</ul>					
				</dt>
				<dd id="tab-content" style="padding-left: 10px;">
					<ul style="display:block;">
                            <?php 
                                     $sql_courseware = "select id,title,intotime,writerid from nettteach_courseware where state='0' order by intotime desc limit 0,7 ";
                                     $result_courseware = $db -> query($sql_courseware);
                                     while($row_courseware = $db ->fetch_array($result_courseware))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_courseware['title']?>">
                                    <span class="date">[<?php echo date('Y-m-d',$row_courseware['intotime'])?>]</span>
                                    <a style="color:blue" href="?do=leftcourseware&coursewareid=<?php echo $row_courseware['id']?>&teacherid=<?php echo $row_courseware['writerid']?>" title=""><?php echo $row_courseware['title']?></a>
                            </li>
                            <?php }?>
					</ul>
					<ul>
                            <?php 
                                     $sql_videos = "select id,title,intotime,belonger from nettteach_videos where state='0' order by intotime desc limit 0,7 ";
                                     $result_videos = $db -> query($sql_videos);
                                     while($row_videos = $db ->fetch_array($result_videos))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_videos['title']?>">
                                    <span class="date">[<?php echo date('Y-m-d',$row_videos['intotime'])?>]</span>
                                    <a style="color:blue" href="?do=viewvideos&video_id=<?php echo $row_videos['id']?>&teacherid=<?php echo $row_videos['belonger']?>" title=""><?php echo $row_videos['title']?></a>
                            </li>
                            <?php }?>
					</ul>
					<ul>
                            <?php 
                                     $sql_exam = "select exam_name,exam_pubtime,exam_id,type from nettteach_exam where 1=1 order by exam_pubtime desc limit 0,7 ";
                                     $result_exam = $db -> query($sql_exam);
                                     while($row_exam = $db ->fetch_array($result_exam))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_exam['exam_name']?>">
                                    <span class="date">[<?php echo date('Y-m-d',$row_exam['exam_pubtime'])?>]</span>
                                    <a style="color:blue" href="?do=<?php if($row_exam['type']==="0") echo 'examinfo';else echo 'exerciseinfo'?>&id=<?php echo $row_exam['exam_id'];?>" title=""><?php echo $row_exam['exam_name']?></a>
                            </li>
                            <?php }?>
					</ul>
				</dd>
			</dl>

			<dl class="box1" style="padding-bottom: 10px">
				<dt>
					<ul id="nav-table2">
<!--						<li class="active" onclick='return secBoard2(0)'><a class="article_golink" href="#">论坛热帖</a></li>-->
						<li class="active" onclick='return secBoard2(0)'><a class="article_golink" href="#">热门视频</a></li>
						<li onclick='return secBoard2(1)'><a class="article_golink" href="#">热门试题</a></li>
					</ul>					
				</dt>
				<dd id="tab-content2" style="padding-left: 10px;">
<!--					<ul style="display:block;">
						<li>
							<span class="date">[09-11]</span>
							<a href="#" title="" style="color:blue">选项卡4</a>
						</li>
					</ul>-->
					<ul style="display:block;">
                            <?php 
                                     $sql_videos = "select id,title,intotime,belonger,times from nettteach_videos where state='0' order by times desc limit 0,7 ";
                                     $result_videos = $db -> query($sql_videos);
                                     while($row_videos = $db ->fetch_array($result_videos))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_videos['title']?>">
<!--                                    <span class="date">[<?php echo date('Y-m-d',$row_videos['intotime'])?>]</span>-->
                                    <span class="date">观看次数:<?php echo $row_videos['times']?></span>
                                    <a style="color:blue" href="?do=viewvideos&video_id=<?php echo $row_videos['id']?>&teacherid=<?php echo $row_videos['belonger']?>" title=""><?php echo $row_videos['title']?></a>
                            </li>
                            <?php }?>
					</ul>
					<ul>
                            <?php 
                                     $sql_exam = "select exam_name,exam_pubtime,exam_id,type,exam_num from nettteach_exam where 1=1 order by exam_num desc limit 0,7 ";
                                     $result_exam = $db -> query($sql_exam);
                                     while($row_exam = $db ->fetch_array($result_exam))
                                    {
                            ?>
                            <li style="height: 35px;line-height: 35px" title="<?php echo $row_exam['exam_name']?>">
<!--                                    <span class="date">[<?php echo date('Y-m-d',$row_exam['exam_pubtime'])?>]</span>-->
                                    <span class="date">做卷人数:<?php echo $row_exam['exam_num']?></span>
                                    <a style="color:blue" href="?do=<?php if($row_exam['type']==="0") echo 'examinfo';else echo 'exerciseinfo'?>&id=<?php echo $row_exam['exam_id'];?>" title=""><?php echo $row_exam['exam_name']?></a>
                            </li>
                            <?php }?>
					</ul>
				</dd>
			</dl>
			<div style="clear:both;"></div>		
		</div>
       <?php include_once('main/common/right.php'); ?>
	<!--center end-->